Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_ENABLED_TRACES

`DBA_ENABLED_TRACES` displays information about enabled SQL traces.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`TRACE_TYPE` | `VARCHAR2(21)` |  | Type of the trace: `CLIENT_ID` `SERVICE` `SERVICE_MODULE` `SERVICE_MODULE_ACTION` `DATABASE`
`PRIMARY_ID` | `VARCHAR2(64)` |  | Primary qualifier (specific client identifier or service name)
`QUALIFIER_ID1` | `VARCHAR2(48)` |  | Secondary qualifier (specific module name)
`QUALIFIER_ID2` | `VARCHAR2(32)` |  | Additional qualifier (specific action name)
`WAITS` | `VARCHAR2(5)` |  | Indicates whether waits are traced (`TRUE`) or not (`FALSE`)
`BINDS` | `VARCHAR2(5)` |  | Indicates whether binds are traced (`TRUE`) or not (`FALSE`)
`INSTANCE_NAME` | `VARCHAR2(16)` |  | Instance name for tracing restricted to named instances